/**
 * 
 */
package arisufascion.com.db;

/**
 * @author Kelvin
 *
 */
public class TblProduct {

	
	public static final String COLUMN_ID = "_id";
	public static final String COLUMN_VIRTUEMART_PRODUCT_ID = "virtuemart_product_id";
	public static final String COLUMN_PRODUCT_NAME = "product_name";
	public static final String COLUMN_PRODUCT_S_DESC="product_s_desc";
	public static final String COLUMN_PRODUCT_DESC="product_desc";
	public static final String COLUMN_PRODUCT_PRICE="product_price";
	public static final String COLUMN_CURRENCY_NAME="currency_name";
	public static final String COLUMN_CATEGORY_NAME="category_name";
	public static final String COLUMN_QUANTITY="quantity";
	public static final String COLUMN_COLOR_ID="color_id";
	public static final String COLUMN_COLOR_QUANTITY="color_quantity";
	public static final String COLUMN_COLOR_IMAGE="color_image";
	public static final String COLUMN_COLOR_SIZE="color_size";
	
	public static final String TABLE_NAME = "tblproduct";
	public static final String TABLE_CREATE = "create table if not exists " + TABLE_NAME + "(" 
			+ COLUMN_ID + " integer primary key AUTOINCREMENT, " 
			+ COLUMN_VIRTUEMART_PRODUCT_ID + " integer, "
			+ COLUMN_PRODUCT_NAME + " text, "
			+ COLUMN_PRODUCT_S_DESC + " text, " 
			+ COLUMN_PRODUCT_DESC + " text, " 
			+ COLUMN_PRODUCT_PRICE + " float, "
			+ COLUMN_CURRENCY_NAME + " text, " 
			+ COLUMN_CATEGORY_NAME + " text, "
			+ COLUMN_COLOR_ID + " integer, "
			+ COLUMN_COLOR_QUANTITY + " integer, "
			+ COLUMN_COLOR_IMAGE + " text, "
			+ COLUMN_COLOR_SIZE + " text, "
			+ COLUMN_QUANTITY+ " integer "
			+ ")";
	
	public static final String TABLE_DROP = "Drop table if exists " + TABLE_NAME;
}
